﻿

--修改菜单
CREATE PROCEDURE [dbo].[proc_App_Menu_Update]
	(
		@ID INT,		
		@Mname nvarchar(50),
		@Mpath varchar(100),
		@Msort INT,
		@EntryPeople varchar(50)
	)
AS

	declare @ename NVARCHAR(20)
	set @ename = (SELECT EName FROM Employee WHERE UserName=@EntryPeople)
	IF(@ename is NULL)
	set @ename=@EntryPeople
	UPDATE App_Menu SET MName = @Mname,MPath = @Mpath,Msort = @Msort,EntryPeople = @ename,EntryTime = GETDATE()
	WHERE ID=@ID
	
	RETURN


